package com.situ.water_BE.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.situ.water_BE.pojo.BeComment;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author Angel
 * @since 2020-12-01
 */
@Mapper
public interface BeCommentMapper extends BaseMapper<BeComment> {
    @Select("select c.*,e.empNmae from be_comment c,sy_emp e where c.EmpID=e.id and c.OrderNo=#{orderNo}")
    public List<Map> queryAllSQL(String orderNo);
    @Select("select o.*,m.MeterTypeName,e.EmpNmae from be_order o,sy_metertype m,sy_emp e where e.id=o.AuditEmpID and o.MeterTypeID=m.id and o.OrderNo=#{orderNo}")
    public Map queryByBeOrderSQL(String orderNo);
    @Select("select *,m.MeterTypeName from be_orderuser u,sy_metertype m where u.MeterTypeID=m.id and u.OrderNo=#{orderNo}")
    public List<Map> queryListBeOrderUserSQL(String orderNo);

}
